Text typed in cell not shown completely due to Wrap Text not selected.
Cause:
The 'Wrap Text' option is not selected.
Solution:
Select 'Cells...' from the 'Format' menu, click the 'Alignment' tab, and select the 'Wrap Text' option.
1) Select the cell to format. (The cell is highlighted.)
2) Select the 'Format' menu and select 'Cells...'. (The Format Cells dialog box appears.)
3) Click the 'Alignment' tab.
4) Select the 'Wrap Text' check box.
the Wrap Text check box
5) Click 'OK'. (All the text typed in the cell should now appear inside the cell.)